/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_proc_ord.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_PROC_ORD
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_proc_ord.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PPM_PROC_ORD::CTable_PPM_PROC_ORD( )
 :NPCRecordSet( )
{
  setTableName( "PPM_PROC_ORD" );
  prepareTable();
  prepareQuery();
 
  TEMPLATE_ID.setField( "TEMPLATE_ID", DATA_CHAR, 30, 0 );
  makeTableItem( TEMPLATE_ID );
  EFF_DATE.setField( "EFF_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EFF_DATE );
  EXP_DATE.setField( "EXP_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EXP_DATE );
  FINISH_DATE.setField( "FINISH_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( FINISH_DATE );
  BEGIN_DATE.setField( "BEGIN_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( BEGIN_DATE );
  END_DATE.setField( "END_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( END_DATE );
  TYPE.setField( "TYPE", DATA_CHAR, 20, 0 );
  makeTableItem( TYPE );
  STATE.setField( "STATE", DATA_CHAR, 6, 0 );
  makeTableItem( STATE );
  PROC_LEVEL.setField( "PROC_LEVEL", DATA_CHAR, 128, 0 );
  makeTableItem( PROC_LEVEL );
  REMARK.setField( "REMARK", DATA_CHAR, 1024, 0 );
  makeTableItem( REMARK );
  ID.setField( "ID", DATA_CHAR, 20, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  NAME.setField( "NAME", DATA_CHAR, 512, 0 );
  makeTableItem( NAME );
  TASK_ID.setField( "TASK_ID", DATA_CHAR, 20, 0 );
  makeTableItem( TASK_ID );
  EXECUTOR_ID.setField( "EXECUTOR_ID", DATA_CHAR, 20, 0 );
  makeTableItem( EXECUTOR_ID );
  EXECUTOR_TYPE.setField( "EXECUTOR_TYPE", DATA_CHAR, 10, 0 );
  makeTableItem( EXECUTOR_TYPE );
  STAFF.setField( "STAFF", DATA_CHAR, 20, 0 );
  makeTableItem( STAFF );
  TEAM_ID.setField( "TEAM_ID", DATA_CHAR, 20, 0 );
  makeTableItem( TEAM_ID );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  MODIFY_DATE.setField( "MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( MODIFY_DATE );
  AUDIT_DATE.setField( "AUDIT_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( AUDIT_DATE );
  DEAL_REASONCD.setField( "DEAL_REASONCD", DATA_CHAR, 128, 0 );
  makeTableItem( DEAL_REASONCD );
  RESULT.setField( "RESULT", DATA_CHAR, 6, 0 );
  makeTableItem( RESULT );
  FLOW_INST_ID.setField( "FLOW_INST_ID", DATA_CHAR, 20, 0 );
  makeTableItem( FLOW_INST_ID );
  TRANS_ID.setField( "TRANS_ID", DATA_CHAR, 20, 0 );
  makeTableItem( TRANS_ID );
  REC_ID.setField( "REC_ID", DATA_CHAR, 20, 0 );
  makeTableItem( REC_ID );
}


CTable_PPM_PROC_ORD::CTable_PPM_PROC_ORD( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_PROC_ORD" );
  prepareTable();
  prepareQuery();
 
  TEMPLATE_ID.setField( "TEMPLATE_ID", DATA_CHAR, 30, 0 );
  makeTableItem( TEMPLATE_ID );
  EFF_DATE.setField( "EFF_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EFF_DATE );
  EXP_DATE.setField( "EXP_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EXP_DATE );
  FINISH_DATE.setField( "FINISH_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( FINISH_DATE );
  BEGIN_DATE.setField( "BEGIN_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( BEGIN_DATE );
  END_DATE.setField( "END_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( END_DATE );
  TYPE.setField( "TYPE", DATA_CHAR, 20, 0 );
  makeTableItem( TYPE );
  STATE.setField( "STATE", DATA_CHAR, 6, 0 );
  makeTableItem( STATE );
  PROC_LEVEL.setField( "PROC_LEVEL", DATA_CHAR, 128, 0 );
  makeTableItem( PROC_LEVEL );
  REMARK.setField( "REMARK", DATA_CHAR, 1024, 0 );
  makeTableItem( REMARK );
  ID.setField( "ID", DATA_CHAR, 20, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  NAME.setField( "NAME", DATA_CHAR, 512, 0 );
  makeTableItem( NAME );
  TASK_ID.setField( "TASK_ID", DATA_CHAR, 20, 0 );
  makeTableItem( TASK_ID );
  EXECUTOR_ID.setField( "EXECUTOR_ID", DATA_CHAR, 20, 0 );
  makeTableItem( EXECUTOR_ID );
  EXECUTOR_TYPE.setField( "EXECUTOR_TYPE", DATA_CHAR, 10, 0 );
  makeTableItem( EXECUTOR_TYPE );
  STAFF.setField( "STAFF", DATA_CHAR, 20, 0 );
  makeTableItem( STAFF );
  TEAM_ID.setField( "TEAM_ID", DATA_CHAR, 20, 0 );
  makeTableItem( TEAM_ID );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  MODIFY_DATE.setField( "MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( MODIFY_DATE );
  AUDIT_DATE.setField( "AUDIT_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( AUDIT_DATE );
  DEAL_REASONCD.setField( "DEAL_REASONCD", DATA_CHAR, 128, 0 );
  makeTableItem( DEAL_REASONCD );
  RESULT.setField( "RESULT", DATA_CHAR, 6, 0 );
  makeTableItem( RESULT );
  FLOW_INST_ID.setField( "FLOW_INST_ID", DATA_CHAR, 20, 0 );
  makeTableItem( FLOW_INST_ID );
  TRANS_ID.setField( "TRANS_ID", DATA_CHAR, 20, 0 );
  makeTableItem( TRANS_ID );
  REC_ID.setField( "REC_ID", DATA_CHAR, 20, 0 );
  makeTableItem( REC_ID );
}

CTable_PPM_PROC_ORD::~CTable_PPM_PROC_ORD( )
{
    close();
}

